SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `hm_data_auth`
-- ----------------------------
DROP TABLE IF EXISTS `hm_data_auth`;
CREATE TABLE `hm_data_auth` (
`id`  bigint(11) NOT NULL AUTO_INCREMENT COMMENT '编号ID' ,
`name`  varchar(34) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称' ,
`note`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注描述' ,
`module_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据来自数据字典' ,
`auth_code`  varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '授权code' ,
`system_default`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'NO' COMMENT '系统默认' ,
`sort`  int(5) NOT NULL COMMENT '排列顺序' ,
`create_time`  datetime NOT NULL COMMENT '创建时间' ,
`create_user`  bigint(11) NOT NULL COMMENT '创建人' ,
`status`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '使用状态' ,
PRIMARY KEY (`id`),
UNIQUE INDEX `id` (`id`) USING BTREE ,
INDEX `auth_code` (`auth_code`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=153

;

-- ----------------------------
-- Records of hm_data_auth
-- ----------------------------
BEGIN;
INSERT INTO `hm_data_auth` VALUES ('1', '添加用户基本信息', '用户管理添加', 'DATA_AUTH_MODULE_SYSTEM_USER', 'com.hm.base.api.SubscriberApi::addSubscriber', 'YES', '1', '2017-12-13 11:16:46', '1', 'ENABLE'), ('2', '删除用户基本信息', '用户管理删除', 'DATA_AUTH_MODULE_SYSTEM_USER', 'com.hm.base.api.SubscriberApi::deleteSubscriber', 'YES', '2', '2017-12-13 11:18:59', '1', 'ENABLE'), ('4', '获取用户基本信息', null, 'DATA_AUTH_MODULE_SYSTEM_USER', 'com.hm.base.api.SubscriberApi::loadCurrentLoginSubscriber', 'YES', '3', '2017-12-14 01:28:15', '1', 'ENABLE'), ('5', '获取指定用户信息', null, 'DATA_AUTH_MODULE_SYSTEM_USER', 'com.hm.base.api.SubscriberApi::loadSubscriberById', 'YES', '4', '2017-12-14 01:28:30', '1', 'ENABLE'), ('6', '修改指定用户密码', null, 'DATA_AUTH_MODULE_SYSTEM_USER', 'com.hm.base.api.SubscriberApi::updateSubscriberPwd', 'YES', '5', '2017-12-14 01:29:40', '1', 'ENABLE'), ('7', '强制修改指定用户密码', null, 'DATA_AUTH_MODULE_SYSTEM_USER', 'com.hm.base.api.SubscriberApi::updateSubscriberPwd', 'YES', '6', '2017-12-14 01:30:32', '1', 'ENABLE'), ('8', '分页查询用户信息', null, 'DATA_AUTH_MODULE_SYSTEM_USER', 'com.hm.base.api.SubscriberApi::query', 'YES', '7', '2017-12-14 01:30:45', '1', 'ENABLE'), ('9', '添加角色基本信息', null, 'DATA_AUTH_MODULE_SYSTEM_ROLE', 'com.hm.base.api.RoleApi::addRole', 'YES', '1', '2017-12-14 01:32:47', '1', 'ENABLE'), ('10', '获取角色基本信息', null, 'DATA_AUTH_MODULE_SYSTEM_ROLE', 'com.hm.base.api.RoleApi::getRole', 'YES', '2', '2017-12-14 01:34:01', '1', 'ENABLE'), ('11', '修改角色基本信息', null, 'DATA_AUTH_MODULE_SYSTEM_ROLE', 'com.hm.base.api.RoleApi::updateRole', 'YES', '3', '2017-12-14 01:34:10', '1', 'ENABLE'), ('12', '删除角色基本信息', null, 'DATA_AUTH_MODULE_SYSTEM_ROLE', 'com.hm.base.api.RoleApi::deleteRole', 'YES', '4', '2017-12-14 01:34:48', '1', 'ENABLE'), ('13', '分页查询角色信息', null, 'DATA_AUTH_MODULE_SYSTEM_ROLE', 'com.hm.base.api.RoleApi::query', 'YES', '5', '2017-12-14 01:35:28', '1', 'ENABLE'), ('14', '获取所有菜单树形数据', null, 'DATA_AUTH_MODULE_SYSTEM_MENU', 'com.hm.base.api.MenuApi::getSystemMenus', 'YES', '1', '2017-12-14 01:35:45', '1', 'ENABLE'), ('15', '获取菜单列表数据', null, 'DATA_AUTH_MODULE_SYSTEM_MENU', 'com.hm.base.api.MenuApi::queryList', 'YES', '2', '2017-12-14 01:37:20', '1', 'ENABLE'), ('16', '获取后台系统版本及授权信息', null, 'DATA_AUTH_MODULE_SYSTEM_COMMON', 'com.hm.base.api.CommonApi::loadBackstageAccreditInfo', 'YES', '1', '2017-12-14 01:41:23', '1', 'ENABLE'), ('17', '加载用户角色列表', null, 'DATA_AUTH_MODULE_SYSTEM_AUTH', 'com.hm.base.api.AuthorizationApi::loadUserRoles', 'YES', '1', '2017-12-14 01:43:16', '1', 'ENABLE'), ('18', '加载用户可用菜单列表', null, 'DATA_AUTH_MODULE_SYSTEM_AUTH', 'com.hm.base.api.AuthorizationApi::loadUserMenus', 'YES', '2', '2017-12-14 01:43:27', '1', 'ENABLE'), ('19', '设置用户所属角色', null, 'DATA_AUTH_MODULE_SYSTEM_AUTH', 'com.hm.base.api.AuthorizationApi::settingUserRoles', 'YES', '3', '2017-12-14 01:44:50', '1', 'ENABLE'), ('20', '设置角色所属菜单', null, 'DATA_AUTH_MODULE_SYSTEM_AUTH', 'com.hm.base.api.AuthorizationApi::settingRoleMenus', 'YES', '4', '2017-12-14 01:45:12', '1', 'ENABLE'), ('21', '加载用户角色所属菜单', null, 'DATA_AUTH_MODULE_SYSTEM_AUTH', 'com.hm.base.api.AuthorizationApi::loadRoleMenus', 'YES', '5', '2017-12-14 01:46:18', '1', 'ENABLE'), ('22', '刷新数据权限', null, 'DATA_AUTH_MODULE_SYSTEM_AUTH', 'com.hm.base.api.AuthorizationApi::refreshDataAuth', 'YES', '6', '2017-12-14 01:47:39', '1', 'ENABLE'), ('23', '加载当前登录用户所属数据权限', null, 'DATA_AUTH_MODULE_SYSTEM_AUTH', 'com.hm.base.api.AuthorizationApi::getCurrentUserDataAuthCodes', 'YES', '7', '2017-12-15 23:17:26', '1', 'ENABLE'), ('24', '加载指定角色数据权限', null, 'DATA_AUTH_MODULE_SYSTEM_AUTH', 'com.hm.base.api.AuthorizationApi::getDataAuthsByRoleId', 'YES', '8', '2017-12-15 23:21:23', '1', 'ENABLE'), ('25', '设置指定角色数据权限', null, 'DATA_AUTH_MODULE_SYSTEM_AUTH', 'com.hm.base.api.AuthorizationApi::settingDataAuthsByRoleId', 'YES', '9', '2017-12-15 23:26:56', '1', 'ENABLE'), ('26', '刷新指定角色数据权限到缓存', null, 'DATA_AUTH_MODULE_SYSTEM_AUTH', 'com.hm.base.api.AuthorizationApi::refreshDataAuthsByRoleId', 'YES', '10', '2017-12-15 23:39:57', '1', 'ENABLE'), ('27', '新增菜单信息', null, 'DATA_AUTH_MODULE_SYSTEM_MENU', 'com.hm.base.api.MenuApi::addMenu', 'YES', '3', '2017-12-16 10:05:54', '1', 'ENABLE'), ('28', '获取菜单基本信息', null, 'DATA_AUTH_MODULE_SYSTEM_MENU', 'com.hm.base.api.MenuApi::getMenu', 'YES', '4', '2017-12-16 10:06:19', '1', 'ENABLE'), ('29', '修改菜单基本信息', null, 'DATA_AUTH_MODULE_SYSTEM_MENU', 'com.hm.base.api.MenuApi::updateMenu', 'YES', '5', '2017-12-16 10:07:07', '1', 'ENABLE'), ('30', '删除菜单基本信息', null, 'DATA_AUTH_MODULE_SYSTEM_MENU', 'com.hm.base.api.MenuApi::deleteMenu', 'YES', '6', '2017-12-16 10:07:37', '1', 'ENABLE'), ('31', '新增数据权限信息', null, 'DATA_AUTH_MODULE_SYSTEM_DATA_AUTH', 'com.hm.base.api.DataAuthApi::addDataAuth', 'YES', '1', '2018-01-25 15:09:06', '1', 'ENABLE'), ('32', '获取数据权限信息', null, 'DATA_AUTH_MODULE_SYSTEM_DATA_AUTH', 'com.hm.base.api.DataAuthApi::getDataAuth', 'YES', '2', '2018-01-25 15:10:08', '1', 'ENABLE'), ('33', '修改数据权限信息', null, 'DATA_AUTH_MODULE_SYSTEM_DATA_AUTH', 'com.hm.base.api.DataAuthApi::updateDataAuth', 'YES', '3', '2018-01-25 15:11:02', '1', 'ENABLE'), ('34', '删除数据权限信息', null, 'DATA_AUTH_MODULE_SYSTEM_DATA_AUTH', 'com.hm.base.api.DataAuthApi::deleteDataAuth', 'YES', '4', '2018-01-25 15:11:40', '1', 'ENABLE'), ('35', '分页系统数据权限记录', null, 'DATA_AUTH_MODULE_SYSTEM_DATA_AUTH', 'com.hm.base.api.DataAuthApi::query', 'YES', '5', '2018-01-25 15:12:07', '1', 'ENABLE'), ('36', '通过CODE加载系统数据字典', null, 'DATA_AUTH_MODULE_SYSTEM_DICT', 'com.hm.base.api.SystemConfigDictApi::loadSystemConfigDictByDictCode', 'YES', '1', '2018-01-26 10:29:25', '1', 'ENABLE'), ('37', '通过字典分类加载系统数据字典列表', null, 'DATA_AUTH_MODULE_SYSTEM_DICT', 'com.hm.base.api.SystemConfigDictApi::loadSystemConfigDictByDictType', 'YES', '2', '2018-01-26 10:30:38', '1', 'ENABLE'), ('38', '分页系统数据字典列表', null, 'DATA_AUTH_MODULE_SYSTEM_DICT', 'com.hm.base.api.SystemConfigDictApi::query', 'YES', '3', '2018-01-26 10:31:26', '1', 'ENABLE'), ('39', '加载系统数据字典所有分类', null, 'DATA_AUTH_MODULE_SYSTEM_DICT', 'com.hm.base.api.SystemConfigDictApi::loadSystemConfigDictTypes', 'YES', '4', '2018-01-30 10:59:43', '1', 'ENABLE'), ('40', '添加数据字典', null, 'DATA_AUTH_MODULE_SYSTEM_DICT', 'com.hm.base.api.SystemConfigDictApi::addSystemConfigDict', 'YES', '5', '2018-01-30 12:00:39', '1', 'ENABLE'), ('41', '获取数据字典信息', null, 'DATA_AUTH_MODULE_SYSTEM_DICT', 'com.hm.base.api.SystemConfigDictApi::getSystemConfigDict', 'YES', '6', '2018-01-30 12:01:23', '1', 'ENABLE'), ('42', '修改数据字典信息', null, 'DATA_AUTH_MODULE_SYSTEM_DICT', 'com.hm.base.api.SystemConfigDictApi::updateSystemConfigDict', 'YES', '7', '2018-01-30 12:02:06', '1', 'ENABLE'), ('43', '删除数据字典信息', null, 'DATA_AUTH_MODULE_SYSTEM_DICT', 'com.hm.base.api.SystemConfigDictApi::deleteSystemConfigDict', 'YES', '8', '2018-01-30 12:02:36', '1', 'ENABLE'), ('44', '文件上传', null, 'DATA_AUTH_MODULE_SYSTEM_COMMON', 'com.hm.base.api.CommonApi::uploadFile', 'YES', '2', '2018-01-30 15:23:51', '1', 'ENABLE'), ('45', '获取系统运行服务器环境', null, 'DATA_AUTH_MODULE_SYSTEM_COMMON', 'com.hm.base.api.CommonApi::envServerinfo', 'YES', '3', '2018-03-07 14:56:43', '1', 'ENABLE'), ('46', '个人中心页面加载', '商城个人中心页面加载', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalCenter', 'NO', '1', '2018-01-25 18:25:37', '1', 'ENABLE'), ('47', '个人信息页面加载', '个人信息页面加载', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalInfo', 'NO', '2', '2018-01-26 11:42:49', '1', 'ENABLE'), ('48', '个人收货地址加载页', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalAddress', 'NO', '3', '2018-01-26 16:17:02', '1', 'ENABLE'), ('49', '安全设置加载页', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalSafety', 'NO', '4', '2018-01-26 16:17:27', '1', 'ENABLE'), ('50', '订单管理加载页', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalOrder', 'NO', '5', '2018-01-26 16:18:05', '1', 'ENABLE'), ('51', '退款管理加载页', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalRefund', 'NO', '6', '2018-01-26 16:18:23', '1', 'ENABLE'), ('52', '优惠券加载页', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalCoupons', 'NO', '7', '2018-01-26 16:48:17', '1', 'ENABLE'), ('53', '红包列表加载页', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalBonus', 'NO', '8', '2018-01-26 16:48:44', '1', 'ENABLE'), ('54', '账单明细加载页', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalBill', 'NO', '9', '2018-01-26 16:49:12', '1', 'ENABLE'), ('55', '我的收藏加载页', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalCollection', 'NO', '9', '2018-01-26 16:49:39', '1', 'ENABLE'), ('56', '我的评价加载页', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalComment', 'NO', '10', '2018-01-26 16:50:02', '1', 'ENABLE'), ('57', '我的消息加载页', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalNews', 'NO', '11', '2018-01-26 16:50:24', '1', 'ENABLE'), ('58', '个人基础信息修改', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.BuyerController::updateUserInfo', 'NO', '12', '2018-01-27 12:35:36', '1', 'ENABLE'), ('59', '七牛云文件上传token获取', '', 'DATA_AUTH_MODULE_SHOPPING_COMMON', 'com.hm.shopping.web.common.CommonController::uploadFileToken', 'NO', '1', '2018-01-27 13:11:13', '1', 'ENABLE'), ('60', '七牛云文件上传', '', 'DATA_AUTH_MODULE_SHOPPING_COMMON', 'com.hm.shopping.web.common.CommonController::uploadFile', 'NO', '2', '2018-01-27 16:26:09', '1', 'ENABLE'), ('61', '更新用户收获地址', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.BuyerController::updateUserAddress', 'NO', '2', '2018-01-29 11:42:25', '1', 'ENABLE'), ('62', '设置用户默认收货地址', '', 'DATA_AUTH_MODULE_SHOPPING_COMMON', 'com.hm.shopping.web.buyer.BuyerController::settingUserDefaultAddress', 'NO', '3', '2018-01-29 11:42:43', '1', 'ENABLE'), ('63', '删除用户收货地址', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.BuyerController::deleteUserAddress', 'NO', '4', '2018-01-29 14:13:40', '1', 'ENABLE'), ('64', '新增新闻公告信息', '', 'DATA_AUTH_MODULE_SHOPPING_NEWSANN', 'com.hm.shopping.api.NewsAnnouncementAction::addNewsAnnouncement', 'NO', '1', '2018-02-05 07:30:01', '1', 'ENABLE'), ('65', '获取新闻公告信息', '', 'DATA_AUTH_MODULE_SHOPPING_NEWSANN', 'com.hm.shopping.api.NewsAnnouncementAction::getNewsAnnouncement', 'NO', '2', '2018-02-05 07:30:24', '1', 'ENABLE'), ('66', '修改新闻公告信息', '', 'DATA_AUTH_MODULE_SHOPPING_NEWSANN', 'com.hm.shopping.api.NewsAnnouncementAction::updateNewsAnnouncement', 'NO', '3', '2018-02-05 07:30:39', '1', 'ENABLE'), ('67', '删除新闻公告信息', '', 'DATA_AUTH_MODULE_SHOPPING_NEWSANN', 'com.hm.shopping.api.NewsAnnouncementAction::deleteNewsAnnouncement', 'NO', '4', '2018-02-05 07:30:55', '1', 'ENABLE'), ('68', '分页新闻公告记录', '', 'DATA_AUTH_MODULE_SHOPPING_NEWSANN', 'com.hm.shopping.api.NewsAnnouncementAction::queryNewsAnnouncement', 'NO', '5', '2018-02-05 07:31:11', '1', 'ENABLE'), ('69', '新增商品信息', '', 'DATA_AUTH_MODULE_SHOPPING_GOODSINT', 'com.hm.shopping.api.GoodsIntroductionApi::addGoodsIntroduction', 'NO', '1', '2018-02-05 07:31:35', '1', 'ENABLE'), ('70', '获取商品信息', '', 'DATA_AUTH_MODULE_SHOPPING_GOODSINT', 'com.hm.shopping.api.GoodsIntroductionApi::getGoodsIntroduction', 'NO', '2', '2018-02-05 07:31:51', '1', 'ENABLE'), ('71', '修改商品信息', '', 'DATA_AUTH_MODULE_SHOPPING_GOODSINT', 'com.hm.shopping.api.GoodsIntroductionApi::updateGoodsIntroduction', 'NO', '3', '2018-02-05 07:32:15', '1', 'ENABLE'), ('72', '删除商品信息', '', 'DATA_AUTH_MODULE_SHOPPING_GOODSINT', 'com.hm.shopping.api.GoodsIntroductionApi::deleteGoodsIntroduction', 'NO', '4', '2018-02-05 07:32:35', '1', 'ENABLE'), ('73', '修改商品上架状态', '', 'DATA_AUTH_MODULE_SHOPPING_GOODSINT', 'com.hm.shopping.api.GoodsIntroductionApi::updateGoodsIntroductionStatus', 'NO', '5', '2018-02-05 07:32:49', '1', 'ENABLE'), ('74', '分页商品分类记录', '', 'DATA_AUTH_MODULE_SHOPPING_CLASSIFICATION', 'com.hm.shopping.api.ClassificationApi::queryClassifications', 'NO', '1', '2018-02-05 07:33:12', '1', 'ENABLE'), ('76', '新增商品分类信息', '', 'DATA_AUTH_MODULE_SHOPPING_CLASSIFICATION', 'com.hm.shopping.api.ClassificationApi::addClassification', 'NO', '3', '2018-02-05 07:34:08', '1', 'ENABLE'), ('77', '获取商品分类信息', '', 'DATA_AUTH_MODULE_SHOPPING_CLASSIFICATION', 'com.hm.shopping.api.ClassificationApi::getClassification', 'NO', '4', '2018-02-05 07:34:27', '1', 'ENABLE'), ('78', '分页商品分类明细记录', '', 'DATA_AUTH_MODULE_SHOPPING_CLASSIFICATION', 'com.hm.shopping.api.ClassificationApi::getClassificationDetailList', 'NO', '2', '2018-02-05 07:35:20', '1', 'ENABLE'), ('79', '修改商品分类信息', '', 'DATA_AUTH_MODULE_SHOPPING_CLASSIFICATION', 'com.hm.shopping.api.ClassificationApi::updateClassification', 'NO', '5', '2018-02-05 07:35:42', '1', 'ENABLE'), ('80', '删除商品分类信息', '', 'DATA_AUTH_MODULE_SHOPPING_CLASSIFICATION', 'com.hm.shopping.api.ClassificationApi::deleteClassification', 'NO', '6', '2018-02-05 07:36:00', '1', 'ENABLE'), ('81', '新增商品分类明细信息', '', 'DATA_AUTH_MODULE_SHOPPING_CLASSIFICATION', 'com.hm.shopping.api.ClassificationApi::addClassificationDetail', 'NO', '7', '2018-02-05 07:36:24', '1', 'ENABLE'), ('82', '获取商品分类明细信息', '', 'DATA_AUTH_MODULE_SHOPPING_CLASSIFICATION', 'com.hm.shopping.api.ClassificationApi::getClassificationDetail', 'NO', '8', '2018-02-05 07:36:40', '1', 'ENABLE'), ('83', '修改商品分类明细信息', '', 'DATA_AUTH_MODULE_SHOPPING_CLASSIFICATION', 'com.hm.shopping.api.ClassificationApi::updateClassificationDetail', 'NO', '9', '2018-02-05 07:36:57', '1', 'ENABLE'), ('84', '删除商品分类明细信息', '', 'DATA_AUTH_MODULE_SHOPPING_CLASSIFICATION', 'com.hm.shopping.api.ClassificationApi::deleteClassificationDetail', 'NO', '10', '2018-02-05 07:37:13', '1', 'ENABLE'), ('85', '新增广告信息', '', 'DATA_AUTH_MODULE_SHOPPING_ADVERTISING', 'com.hm.shopping.api.AdvertisingApi::addAdvertising', 'NO', '1', '2018-02-05 07:37:41', '1', 'ENABLE'), ('86', '获取广告信息', '', 'DATA_AUTH_MODULE_SHOPPING_ADVERTISING', 'com.hm.shopping.api.AdvertisingApi::getAdvertising', 'NO', '2', '2018-02-05 07:37:56', '1', 'ENABLE'), ('87', '修改广告信息', '', 'DATA_AUTH_MODULE_SHOPPING_ADVERTISING', 'com.hm.shopping.api.AdvertisingApi::updateAdvertising', 'NO', '3', '2018-02-05 07:38:12', '1', 'ENABLE'), ('88', '删除广告信息', '', 'DATA_AUTH_MODULE_SHOPPING_ADVERTISING', 'com.hm.shopping.api.AdvertisingApi::deleteAdvertising', 'NO', '4', '2018-02-05 07:38:31', '1', 'ENABLE'), ('89', '分页广告记录', '', 'DATA_AUTH_MODULE_SHOPPING_ADVERTISING', 'com.hm.shopping.api.AdvertisingApi::queryAdvertising', 'NO', '5', '2018-02-05 07:38:48', '1', 'ENABLE'), ('90', '分页商品信息记录', '', 'DATA_AUTH_MODULE_SHOPPING_GOODSINT', 'com.hm.shopping.api.GoodsIntroductionApi::queryGoodsIntroduction', 'NO', '5', '2018-02-07 08:58:54', '1', 'ENABLE'), ('91', '购物车页面加载', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalShopcart', 'NO', '12', '2018-02-09 07:33:17', '1', 'ENABLE'), ('92', '加入购物车', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.BuyerController::joinShopcart', 'NO', '5', '2018-02-09 08:57:14', '1', 'ENABLE'), ('94', '移除购物车', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.BuyerController::removeShopcart', 'NO', '6', '2018-02-09 09:05:40', '1', 'ENABLE'), ('95', '购物车商品数量修改', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.BuyerController::addShopcart', 'NO', '13', '2018-02-23 08:10:36', '1', 'ENABLE'), ('97', '修改购物车商品是否勾选中', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.BuyerController::updateShopcartSelected', 'NO', '14', '2018-02-23 08:37:50', '1', 'ENABLE'), ('98', '购物车支付页面跳转', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalPay', 'NO', '14', '2018-02-23 09:08:41', '1', 'ENABLE'), ('99', '用户订单支付', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalOrderPay', 'NO', '15', '2018-02-24 06:56:05', '1', 'ENABLE'), ('100', '分页查询订单信息', '', 'DATA_AUTH_MODULE_SHOPPING_ORDER', 'com.hm.shopping.api.OrderApi::queryBuyerGoodsSnapshots', 'NO', '1', '2018-02-26 03:35:12', '1', 'ENABLE'), ('101', '商品订单发货', '', 'DATA_AUTH_MODULE_SHOPPING_ORDER', 'com.hm.shopping.api.OrderApi::finishOrderCourier', 'NO', '2', '2018-02-27 02:10:33', '1', 'ENABLE'), ('102', '收藏页面跳转', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.PersonalCenterController::personalFavorites', 'NO', '16', '2018-03-01 04:02:23', '1', 'ENABLE'), ('103', '添加商品收藏', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.BuyerController::addFavorites', 'NO', '17', '2018-03-01 04:03:18', '1', 'ENABLE'), ('104', '删除商品收藏', '', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', 'com.hm.shopping.web.buyer.BuyerController::delFavorites', 'NO', '18', '2018-03-01 04:03:43', '1', 'ENABLE');
INSERT INTO `hm_data_auth` VALUES ('105', '加载平台列表', '', 'DATA_AUTH_MODULE_SYSTEM_COMMON', 'com.hm.base.api.CommonApi::loadBusPlatforms', 'YES', '4', '2018-03-10 13:47:07', '1', 'ENABLE'), ('106', '加载业务系统模块列表', '', 'DATA_AUTH_MODULE_SYSTEM_REQ_LOG', 'com.hm.base.api.ReqLogApi::loadBusPlatforModules', 'YES', '1', '2018-03-10 13:47:26', '1', 'ENABLE'), ('107', '分页操作日志记录', '', 'DATA_AUTH_MODULE_SYSTEM_REQ_LOG', 'com.hm.base.api.ReqLogApi::query', 'YES', '2', '2018-03-10 13:48:19', '1', 'ENABLE'), ('108', '修改用户登录错误次数过多登陆锁定状态', '', 'DATA_AUTH_MODULE_SYSTEM_USER', 'com.hm.base.api.SubscriberApi::updateLoginLock', 'YES', '9', '2018-03-12 03:29:04', '1', 'ENABLE'), ('109', '加载平台数据权限列表', null, 'DATA_AUTH_MODULE_SYSTEM_COMMON', 'com.hm.base.api.CommonApi::loadBusPlatformDataAuths', 'YES', '5', '2018-03-16 18:41:26', '1', 'ENABLE'), ('110', '新增链接信息', '', 'DATA_AUTH_MODULE_CMS_LINK', 'com.hm.cms.api.LinkApi::addLink', 'NO', '1', '2018-03-17 09:19:08', '1', 'ENABLE'), ('111', '获取链接信息', '', 'DATA_AUTH_MODULE_CMS_LINK', 'com.hm.cms.api.LinkApi::getLink', 'NO', '2', '2018-03-17 09:19:31', '1', 'ENABLE'), ('112', '修改链接信息', '', 'DATA_AUTH_MODULE_CMS_LINK', 'com.hm.cms.api.LinkApi::updateLink', 'NO', '3', '2018-03-17 09:20:17', '1', 'ENABLE'), ('113', '删除链接信息', '', 'DATA_AUTH_MODULE_CMS_LINK', 'com.hm.cms.api.LinkApi::deleteLink', 'NO', '4', '2018-03-17 09:21:22', '1', 'ENABLE'), ('114', '分页系统链接记录', '', 'DATA_AUTH_MODULE_CMS_LINK', 'com.hm.cms.api.LinkApi::queryLink', 'NO', '5', '2018-03-17 09:21:42', '1', 'ENABLE'), ('115', '获取站点信息', '', 'DATA_AUTH_MODULE_CMS_SITE_INFO', 'com.hm.cms.api.SiteInfoApi::getSiteInfo', 'NO', '1', '2018-03-18 17:29:09', '1', 'ENABLE'), ('116', '修改站点信息', '', 'DATA_AUTH_MODULE_CMS_SITE_INFO', 'com.hm.cms.api.SiteInfoApi::updateSiteInfo', 'NO', '2', '2018-03-18 17:29:28', '1', 'ENABLE'), ('117', '新增导航分类信息', '', 'DATA_AUTH_MODULE_CMS_CLASSIFICATION', 'com.hm.cms.api.ClassificationApi::addClassification', 'NO', '1', '2018-03-19 07:48:43', '1', 'ENABLE'), ('118', '获取导航分类信息', '', 'DATA_AUTH_MODULE_CMS_CLASSIFICATION', 'com.hm.cms.api.ClassificationApi::getClassification', 'NO', '2', '2018-03-19 07:49:02', '1', 'ENABLE'), ('119', '修改导航分类信息', '', 'DATA_AUTH_MODULE_CMS_CLASSIFICATION', 'com.hm.cms.api.ClassificationApi::updateClassification', 'NO', '3', '2018-03-19 07:49:27', '1', 'ENABLE'), ('120', '删除导航分类信息', '', 'DATA_AUTH_MODULE_CMS_CLASSIFICATION', 'com.hm.cms.api.ClassificationApi::deleteClassification', 'NO', '4', '2018-03-19 07:50:07', '1', 'ENABLE'), ('121', '模糊查询分类导航数据', '', 'DATA_AUTH_MODULE_CMS_CLASSIFICATION', 'com.hm.cms.api.ClassificationApi::queryClassificationList', 'NO', '5', '2018-03-19 07:51:25', '1', 'ENABLE'), ('122', '加载导航分类树', '', 'DATA_AUTH_MODULE_CMS_CLASSIFICATION', 'com.hm.cms.api.ClassificationApi::getClassificationTree', 'NO', '6', '2018-03-19 07:51:47', '1', 'ENABLE'), ('123', '新增标签信息', '', 'DATA_AUTH_MODULE_CMS_LABLE_TAG', 'com.hm.cms.api.LabelTagApi::addLabelTag', 'NO', '1', '2018-03-19 10:06:26', '1', 'ENABLE'), ('124', '获取标签信息', '', 'DATA_AUTH_MODULE_CMS_LABLE_TAG', 'com.hm.cms.api.LabelTagApi::getLabelTag', 'NO', '2', '2018-03-19 10:06:41', '1', 'ENABLE'), ('125', '修改标签信息', '', 'DATA_AUTH_MODULE_CMS_LABLE_TAG', 'com.hm.cms.api.LabelTagApi::updateLabelTag', 'NO', '3', '2018-03-19 10:07:00', '1', 'ENABLE'), ('126', '删除标签信息', '', 'DATA_AUTH_MODULE_CMS_LABLE_TAG', 'com.hm.cms.api.LabelTagApi::deleteLabelTag', 'NO', '4', '2018-03-19 10:07:15', '1', 'ENABLE'), ('127', '分页系统标签记录', '', 'DATA_AUTH_MODULE_CMS_LABLE_TAG', 'com.hm.cms.api.LabelTagApi::queryLabelTag', 'NO', '5', '2018-03-19 10:07:28', '1', 'ENABLE'), ('128', '新增文章信息', '', 'DATA_AUTH_MODULE_CMS_ARTICLE', 'com.hm.cms.api.ArticleApi::addArticle', 'NO', '1', '2018-03-19 10:51:54', '1', 'ENABLE'), ('129', '获取文章信息', '', 'DATA_AUTH_MODULE_CMS_ARTICLE', 'com.hm.cms.api.ArticleApi::getArticle', 'NO', '2', '2018-03-19 10:52:06', '1', 'ENABLE'), ('130', '修改文章信息', '', 'DATA_AUTH_MODULE_CMS_ARTICLE', 'com.hm.cms.api.ArticleApi::updateArticle', 'NO', '3', '2018-03-19 10:52:22', '1', 'ENABLE'), ('131', '删除文章信息', '', 'DATA_AUTH_MODULE_CMS_ARTICLE', 'com.hm.cms.api.ArticleApi::deleteLink', 'NO', '4', '2018-03-19 10:52:35', '1', 'ENABLE'), ('132', '分页系统文章记录', '', 'DATA_AUTH_MODULE_CMS_ARTICLE', 'com.hm.cms.api.ArticleApi::queryLink', 'NO', '5', '2018-03-19 10:52:48', '1', 'ENABLE'), ('133', 'BaiduUE统一调用入口', '', 'DATA_AUTH_MODULE_CMS_UE', 'com.hm.cms.api.UeditorApi::getInvoke', 'NO', '1', '2018-03-20 04:56:06', '1', 'ENABLE'), ('134', 'BaiduUE统一调用入口,上传图片、视频等', '', 'DATA_AUTH_MODULE_CMS_UE', 'com.hm.cms.api.UeditorApi::postInvoke', 'NO', '2', '2018-03-20 04:56:26', '1', 'ENABLE'), ('135', '加载所有标签信息', '', 'DATA_AUTH_MODULE_CMS_LABLE_TAG', 'com.hm.cms.api.LabelTagApi::loadLabelTags', 'NO', '6', '2018-03-20 09:07:02', '1', 'ENABLE'), ('136', '文件上传', '', 'DATA_AUTH_MODULE_CMS_COMMON', 'com.hm.cms.api.CommonAction::uploadFile', 'NO', '1', '2018-03-21 02:28:37', '1', 'ENABLE'), ('137', '加载文章所有标签', '', 'DATA_AUTH_MODULE_CMS_ARTICLE', 'com.hm.cms.api.ArticleApi::loadArticleLabelTags', 'NO', '6', '2018-03-21 03:58:59', '1', 'ENABLE'), ('138', '新增黑名单信息', '', 'DATA_AUTH_MODULE_CMS_BLACK_IP_LIST', 'com.hm.cms.api.BlacklistApi::addBlacklist', 'NO', '1', '2018-03-21 07:15:45', '1', 'ENABLE'), ('139', '获取黑名单信息', '', 'DATA_AUTH_MODULE_CMS_BLACK_IP_LIST', 'com.hm.cms.api.BlacklistApi::getBlacklist', 'NO', '2', '2018-03-21 07:16:00', '1', 'ENABLE'), ('140', '删除黑名单信息', '', 'DATA_AUTH_MODULE_CMS_BLACK_IP_LIST', 'com.hm.cms.api.BlacklistApi::deleteBlacklist', 'NO', '3', '2018-03-21 07:16:14', '1', 'ENABLE'), ('141', '分页系统黑名单记录', '', 'DATA_AUTH_MODULE_CMS_BLACK_IP_LIST', 'com.hm.cms.api.BlacklistApi::queryBlacklist', 'NO', '4', '2018-03-21 07:16:30', '1', 'ENABLE'), ('142', '新增广告资源信息', '', 'DATA_AUTH_MODULE_CMS_AD_RESOURCES', 'com.hm.cms.api.AdvertResourcesApi::addAdvertResources', 'NO', '1', '2018-03-21 07:47:16', '1', 'ENABLE'), ('143', '获取广告资源信息', '', 'DATA_AUTH_MODULE_CMS_AD_RESOURCES', 'com.hm.cms.api.AdvertResourcesApi::getAdvertResources', 'NO', '2', '2018-03-21 07:47:29', '1', 'ENABLE'), ('144', '修改广告资源信息', '', 'DATA_AUTH_MODULE_CMS_AD_RESOURCES', 'com.hm.cms.api.AdvertResourcesApi::updateAdvertResources', 'NO', '3', '2018-03-21 07:47:42', '1', 'ENABLE'), ('145', '删除广告资源信息', '', 'DATA_AUTH_MODULE_CMS_AD_RESOURCES', 'com.hm.cms.api.AdvertResourcesApi::deleteAdvertResources', 'NO', '4', '2018-03-21 07:47:57', '1', 'ENABLE'), ('146', '分页系统广告资源记录', '', 'DATA_AUTH_MODULE_CMS_AD_RESOURCES', 'com.hm.cms.api.AdvertResourcesApi::queryAdvertResources', 'NO', '5', '2018-03-21 07:48:12', '1', 'ENABLE'), ('147', '加载广告播放位置', '', 'DATA_AUTH_MODULE_CMS_AD_RESOURCES', 'com.hm.cms.api.AdvertResourcesApi::loadAdvertLocations', 'NO', '6', '2018-03-21 08:16:55', '1', 'ENABLE'), ('148', '新增广告投放信息', '', 'DATA_AUTH_MODULE_CMS_ADVERT', 'com.hm.cms.api.AdvertApi::addAdvert', 'NO', '1', '2018-03-22 02:48:21', '1', 'ENABLE'), ('149', '获取广告投放信息', '', 'DATA_AUTH_MODULE_CMS_ADVERT', 'com.hm.cms.api.AdvertApi::getAdvert', 'NO', '2', '2018-03-22 02:48:36', '1', 'ENABLE'), ('150', '删除广告投放信息', '', 'DATA_AUTH_MODULE_CMS_ADVERT', 'com.hm.cms.api.AdvertApi::deleteAdvert', 'NO', '3', '2018-03-22 02:48:53', '1', 'ENABLE'), ('151', '分页系统广告投放记录', '', 'DATA_AUTH_MODULE_CMS_ADVERT', 'com.hm.cms.api.AdvertApi::queryAdvert', 'NO', '4', '2018-03-22 02:49:08', '1', 'ENABLE'), ('152', '加载系统广告资源', '', 'DATA_AUTH_MODULE_CMS_AD_RESOURCES', 'com.hm.cms.api.AdvertResourcesApi::loadAdvertResources', 'NO', '7', '2018-03-22 06:04:17', '1', 'ENABLE');
COMMIT;

-- ----------------------------
-- Table structure for `hm_menu`
-- ----------------------------
DROP TABLE IF EXISTS `hm_menu`;
CREATE TABLE `hm_menu` (
`id`  bigint(11) NOT NULL AUTO_INCREMENT COMMENT '编号ID' ,
`name`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称' ,
`note`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注描述' ,
`uri`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求地址' ,
`ico`  varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标' ,
`parent_id`  bigint(11) UNSIGNED ZEROFILL NOT NULL COMMENT '上级id' ,
`system_default`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'NO' COMMENT '系统默认' ,
`sort`  bigint(11) NULL DEFAULT NULL COMMENT '排列顺序' ,
`create_user`  bigint(11) NULL DEFAULT NULL COMMENT '创建人' ,
`create_time`  datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间' ,
`status`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用状态' ,
PRIMARY KEY (`id`, `create_time`),
UNIQUE INDEX `id` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=45

;

-- ----------------------------
-- Records of hm_menu
-- ----------------------------
BEGIN;
INSERT INTO `hm_menu` VALUES ('1', '我的桌面', '欢迎页', '#!workbench.html', '&#xe681;', '00000000000', 'YES', '1', '1', '2017-06-05 14:32:00', 'ENABLE'), ('3', '用户管理', '用户管理', '#!view/system/sub/subscriber-list.html', '', '00000000007', 'YES', '1', '1', '2017-06-05 14:32:00', 'ENABLE'), ('4', '角色管理', '角色管理', '#!view/system/role/role-list.html', '', '00000000007', 'YES', '2', '1', '2017-06-05 14:32:00', 'ENABLE'), ('5', '菜单管理', '菜单管理', '#!view/system/menu/menu-list.html', '', '00000000007', 'YES', '3', '1', '2017-06-05 14:32:00', 'ENABLE'), ('6', '接口管理', '数据接口管理', '#!view/system/dtauth/dtauth-list.html', null, '00000000007', 'YES', '4', '1', '2017-12-16 10:32:06', 'ENABLE'), ('7', '系统管理', 'Manager基础数据管理平台', '', '&#xe63c;', '00000000000', 'YES', '2', '1', '2017-06-05 14:32:00', 'ENABLE'), ('8', '字典管理', '字典管理', '#!view/system/dict/dict-list.html', '', '00000000007', 'YES', '5', '1', '2017-06-05 14:32:00', 'ENABLE'), ('23', '商城管理', '', '', '&#xe673;', '00000000000', 'YES', '3', '1', '2017-12-16 10:31:34', 'ENABLE'), ('24', '分类管理', '', '#!view/shopping/classification/classification-list.html', '', '00000000023', 'YES', '1', '1', '2017-12-16 10:31:59', 'ENABLE'), ('26', '商品管理', null, '#!view/shopping/goodsint/goodsint-list.html', null, '00000000023', 'YES', '2', '1', '2018-02-06 17:08:08', 'ENABLE'), ('27', '公告管理', null, '#!view/shopping/newsann/newsann-list.html', null, '00000000023', 'YES', '3', '1', '2018-02-07 15:33:27', 'ENABLE'), ('28', '订单管理', null, '#!view/shopping/order/order-list.html', null, '00000000023', 'YES', '4', '1', '2018-02-09 15:08:42', 'ENABLE'), ('29', '物流管理', null, '#!view/shopping/newsann/newsann-list.html', null, '00000000023', 'YES', '5', '1', '2018-02-09 15:09:06', 'ENABLE'), ('30', '评论管理', null, '#!view/shopping/newsann/newsann-list.html', null, '00000000023', 'YES', '6', '1', '2018-02-09 15:09:33', 'ENABLE'), ('31', '操作日志', null, '#!view/system/reqlog/llog-list.html', null, '00000000007', 'YES', '6', '1', '2018-03-10 13:49:53', 'ENABLE'), ('33', 'O&nbsp;A&nbsp;管理', null, null, '&#xe639;', '00000000000', 'YES', '6', '1', '2018-03-11 11:23:09', 'ENABLE'), ('34', '网站管理', null, null, '&#xe72b;', '00000000000', 'YES', '4', '1', '2018-03-11 11:23:37', 'ENABLE'), ('35', '客服管理', null, null, '&#xe6d0;', '00000000000', 'YES', '5', '1', '2018-03-11 11:26:25', 'ENABLE'), ('36', '栏目管理', '', '#!view/cms/clas/clas-list.html', '', '00000000034', 'YES', '2', '1', '2018-03-17 06:30:34', 'ENABLE'), ('37', '标签管理', '', '#!view/cms/ltag/ltag-list.html', '', '00000000034', 'YES', '3', '1', '2018-03-17 06:30:50', 'ENABLE'), ('38', '访问管理', '', '#!view/cms/black/black-list.html', null, '00000000034', 'YES', '7', '1', '2018-03-17 06:31:07', 'ENABLE'), ('39', '站点信息', '', '#!view/cms/sinfo/site-info.html', null, '00000000034', 'YES', '1', '1', '2018-03-17 06:31:51', 'ENABLE'), ('40', '链接管理', '', '#!view/cms/link/link-list.html', '', '00000000034', 'YES', '1', '1', '2018-03-17 06:32:07', 'ENABLE'), ('41', '广告资源', '', '#!view/cms/adresource/adresource-list.html', '', '00000000034', 'YES', '5', '1', '2018-03-17 06:32:16', 'ENABLE'), ('42', '广告投放', '', '#!view/cms/advert/advert-list.html', '', '00000000034', 'YES', '6', '1', '2018-03-17 06:32:23', 'ENABLE'), ('43', '内容管理', '', '#!view/cms/article/article-list.html', '', '00000000034', 'YES', '4', '1', '2018-03-17 06:32:28', 'ENABLE'), ('44', '站点统计', '', '', '', '00000000034', 'YES', '8', '1', '2018-03-17 06:34:24', 'DISABLE');
COMMIT;

-- ----------------------------
-- Table structure for `hm_nation_region`
-- ----------------------------
DROP TABLE IF EXISTS `hm_nation_region`;
CREATE TABLE `hm_nation_region` (
`id`  bigint(11) NOT NULL AUTO_INCREMENT COMMENT '编号ID' ,
`region_name`  varchar(34) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域名称' ,
`parent_id`  bigint(11) NOT NULL COMMENT '上级编号id' ,
`region_code`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域code' ,
`sort`  int(11) NOT NULL COMMENT '排列顺序' ,
`create_time`  datetime NOT NULL COMMENT '创建时间' ,
`create_user`  bigint(11) NOT NULL COMMENT '创建人' ,
`status`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '使用状态' ,
PRIMARY KEY (`id`),
UNIQUE INDEX `id` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='系统设置全国地址'
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of hm_nation_region
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `hm_req_log`
-- ----------------------------
DROP TABLE IF EXISTS `hm_req_log`;
CREATE TABLE `hm_req_log` (
`id`  bigint(11) NOT NULL AUTO_INCREMENT COMMENT '编号ID' ,
`req_ip`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '请求ip地址' ,
`platform`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '业务系统' ,
`module`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '业务系统模块' ,
`describes`  varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '日志描述信息' ,
`method`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '请求方式' ,
`uri`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '请求路径' ,
`params`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求参数' ,
`create_time`  datetime NOT NULL COMMENT '创建时间' ,
`create_user`  bigint(11) NULL DEFAULT NULL COMMENT '创建人' ,
`status`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '使用状态' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=113

;

-- ----------------------------
-- Records of hm_req_log
-- ----------------------------
BEGIN;
INSERT INTO `hm_req_log` VALUES ('3', '127.0.0.1', 'IBSM_MANAGER', 'AUTHORIZATION_MODULE', '加载当前登录用户所属数据权限', 'PATCH', 'http://localhost/restful/base/v1.0/auth/user/data/auth/codes', '[]', '2018-03-09 15:26:02', '1', 'ENABLE'), ('4', '127.0.0.1', 'IBSM_MANAGER', 'AUTHORIZATION_MODULE', '加载用户菜单列表', 'GET', 'http://localhost/restful/base/v1.0/auth/user/menus', '[]', '2018-03-09 15:26:02', '1', 'ENABLE'), ('5', '127.0.0.1', 'IBSM_MANAGER', 'AUTHORIZATION_MODULE', '新增角色:RoleVo(id=null, name=rfe, note=e, systemCfg=false, createTime=0, createUser=1)', 'POST', 'http://localhost/restful/base/v1.0/role', '[RoleVo(id=null, name=rfe, note=e, systemCfg=false, createTime=0, createUser=null)]', '2018-03-09 15:29:59', '1', 'ENABLE'), ('6', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_ROLE_MODULE', '删除角色9信息', 'DELETE', 'http://localhost/restful/base/v1.0/role', '[[9]]', '2018-03-10 13:15:18', '1', 'ENABLE'), ('7', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_ROLE_MODULE', '删除角色[10]信息', 'DELETE', 'http://localhost/restful/base/v1.0/role', '[[10]]', '2018-03-10 14:20:46', '1', 'ENABLE'), ('8', '222.211.138.225', 'IBSM_MANAGER', 'IBSM_MANAGER_ROLE_MODULE', '新增角色:panpan', 'POST', 'http://manager.machu.wang/restful/base/v1.0/role', '[RoleVo(id=null, name=panpan, note=, systemCfg=false, createTime=0, createUser=null)]', '2018-03-10 09:10:25', '1', 'ENABLE'), ('9', '222.211.138.225', 'IBSM_MANAGER', 'IBSM_MANAGER_ROLE_MODULE', '修改角色[11]信息', 'PUT', 'http://manager.machu.wang/restful/base/v1.0/role/11', '[11, RoleVo(id=null, name=panpan, note=5467风格诱惑, systemCfg=false, createTime=0, createUser=null)]', '2018-03-10 09:10:32', '1', 'ENABLE'), ('10', '222.211.138.225', 'IBSM_MANAGER', 'IBSM_MANAGER_ROLE_MODULE', '删除角色[11]信息', 'DELETE', 'http://manager.machu.wang/restful/base/v1.0/role', '[[11]]', '2018-03-10 09:10:40', '1', 'ENABLE'), ('11', '222.211.138.225', 'IBSM_MANAGER', 'IBSM_MANAGER_DATA_AUTH_MODULE', '删除[102]数据权限信息', 'DELETE', 'http://manager.machu.wang/restful/base/v1.0/dtauth', '[[102]]', '2018-03-10 09:13:22', '20', 'ENABLE'), ('12', '222.211.138.225', 'IBSM_MANAGER', 'IBSM_MANAGER_MENU_MODULE', '删除[32]菜单信息', 'DELETE', 'http://manager.machu.wang/restful/base/v1.0/menu', '[[32]]', '2018-03-10 09:15:08', '1', 'ENABLE'), ('13', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 10:46:53', '-1', 'ENABLE'), ('14', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 10:47:00', '-1', 'ENABLE'), ('15', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 10:48:08', '-1', 'ENABLE'), ('16', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 10:57:19', '-1', 'ENABLE'), ('17', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 10:57:32', '-1', 'ENABLE'), ('18', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '设置角色7所属菜单[1,7,3,4,5,6,8]', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth/setting/user/role/menus', '[7, [1, 7, 3, 4, 5, 6, 8]]', '2018-03-12 02:58:57', '1', 'ENABLE'), ('19', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '设置角色7数据权限:36,37,38,39,35,17,18,21,23,24,16,45,14,15,28,10,13,4,5,8', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth/setting/role/data_auth', '[7, [36, 37, 38, 39, 35, 17, 18, 21, 23, 24, 16, 45, 14, 15, 28, 10, 13, 4, 5, 8]]', '2018-03-12 02:59:09', '1', 'ENABLE'), ('20', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '设置用户20角色[7,3]', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth/setting/user/roles', '[20, [7, 3]]', '2018-03-12 03:00:25', '20', 'ENABLE'), ('21', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 11:42:52', '-1', 'ENABLE'), ('22', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 11:43:45', '-1', 'ENABLE'), ('23', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1235]', '2018-03-12 11:43:52', '-1', 'ENABLE'), ('24', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1235]', '2018-03-12 11:43:52', '-1', 'ENABLE'), ('25', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1235]', '2018-03-12 11:43:53', '-1', 'ENABLE'), ('26', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1235]', '2018-03-12 11:43:54', '-1', 'ENABLE'), ('27', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1235]', '2018-03-12 11:43:56', '-1', 'ENABLE'), ('28', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 11:44:00', '-1', 'ENABLE'), ('29', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 11:44:45', '-1', 'ENABLE'), ('30', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 11:46:40', '-1', 'ENABLE'), ('31', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1235]', '2018-03-12 11:47:26', '-1', 'ENABLE'), ('32', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1235]', '2018-03-12 11:47:27', '-1', 'ENABLE'), ('33', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1235]', '2018-03-12 11:47:27', '-1', 'ENABLE'), ('34', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1235]', '2018-03-12 11:47:28', '-1', 'ENABLE'), ('35', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1235]', '2018-03-12 11:47:28', '-1', 'ENABLE'), ('36', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1235]', '2018-03-12 11:47:28', '-1', 'ENABLE'), ('37', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1235]', '2018-03-12 11:47:28', '-1', 'ENABLE'), ('38', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 11:47:32', '-1', 'ENABLE'), ('39', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 11:48:09', '-1', 'ENABLE'), ('40', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 11:49:47', '-1', 'ENABLE'), ('41', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 11:52:01', '-1', 'ENABLE'), ('42', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_SUBSCRIBER_MODULE', '修改用户[1]登录错误次数过多登陆锁定状态', 'PATCH', 'http://localhost:10000/restful/base/v1.0/subscriber/login/lock/%7BsubscriberId%7D', '[1, NO]', '2018-03-12 12:00:29', '-1', 'ENABLE'), ('43', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 12:00:49', '-1', 'ENABLE'), ('44', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:00:57', '-1', 'ENABLE'), ('45', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:01:00', '-1', 'ENABLE'), ('46', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:01:03', '-1', 'ENABLE'), ('47', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:01:05', '-1', 'ENABLE'), ('48', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:01:07', '-1', 'ENABLE'), ('49', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:01:11', '-1', 'ENABLE'), ('50', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:01:13', '-1', 'ENABLE'), ('51', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:01:14', '-1', 'ENABLE'), ('52', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:01:16', '-1', 'ENABLE'), ('53', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:01:17', '-1', 'ENABLE'), ('54', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:01:18', '-1', 'ENABLE'), ('55', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:01:18', '-1', 'ENABLE'), ('56', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:01:18', '-1', 'ENABLE'), ('57', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_SUBSCRIBER_MODULE', '修改用户[1]登录错误次数过多登陆锁定状态', 'PATCH', 'http://localhost:10000/restful/base/v1.0/subscriber/login/lock/%7BsubscriberId%7D', '[1, NO]', '2018-03-12 12:04:11', '-1', 'ENABLE'), ('58', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:04:16', '-1', 'ENABLE'), ('59', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:04:18', '-1', 'ENABLE'), ('60', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:04:20', '-1', 'ENABLE'), ('61', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[admin, admin_1234]', '2018-03-12 12:04:21', '-1', 'ENABLE'), ('62', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_SUBSCRIBER_MODULE', '修改用户[1]登录错误次数过多登陆锁定状态', 'PATCH', 'http://localhost:10000/restful/base/v1.0/subscriber/login/lock/%7BsubscriberId%7D', '[1, NO]', '2018-03-12 14:24:57', '-1', 'ENABLE'), ('63', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[test, test123]', '2018-03-12 06:25:02', '-1', 'ENABLE'), ('64', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 06:25:07', '-1', 'ENABLE'), ('65', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[test, test123]', '2018-03-12 14:25:51', '-1', 'ENABLE'), ('66', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_SUBSCRIBER_MODULE', '修改用户[20]登录错误次数过多登陆锁定状态', 'PATCH', 'http://localhost:10000/restful/base/v1.0/subscriber/login/lock/%7BsubscriberId%7D', '[20, NO]', '2018-03-12 14:27:20', '-1', 'ENABLE'), ('67', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[test, test123]', '2018-03-12 14:30:46', '-1', 'ENABLE'), ('68', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[test, test123]', '2018-03-12 14:30:49', '-1', 'ENABLE'), ('69', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[test, test123]', '2018-03-12 14:30:51', '-1', 'ENABLE'), ('70', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[test, test123]', '2018-03-12 14:30:52', '-1', 'ENABLE'), ('71', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[test, test123]', '2018-03-12 14:30:53', '-1', 'ENABLE'), ('72', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_SUBSCRIBER_MODULE', '修改用户[20]登录错误次数过多登陆锁定状态', 'PATCH', 'http://localhost:10000/restful/base/v1.0/subscriber/login/lock/%7BsubscriberId%7D', '[20, NO]', '2018-03-12 14:32:01', '-1', 'ENABLE'), ('73', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_SUBSCRIBER_MODULE', '修改用户[20]登录错误次数过多登陆锁定状态', 'PATCH', 'http://localhost:10000/restful/base/v1.0/subscriber/login/lock/%7BsubscriberId%7D', '[20, NO]', '2018-03-12 14:33:49', '-1', 'ENABLE'), ('74', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[test, test123]', '2018-03-12 14:33:53', '-1', 'ENABLE'), ('75', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[test, test123]', '2018-03-12 14:33:57', '-1', 'ENABLE'), ('76', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[test, test123]', '2018-03-12 14:33:58', '-1', 'ENABLE'), ('77', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://localhost:10000/restful/base/v1.0/auth', '[test, test123]', '2018-03-12 14:33:58', '-1', 'ENABLE'), ('78', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 06:37:00', '-1', 'ENABLE'), ('79', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 06:57:25', '-1', 'ENABLE'), ('80', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 06:57:42', '-1', 'ENABLE'), ('81', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 06:59:12', '-1', 'ENABLE'), ('82', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'GET', 'http://manager.machu.wang/restful/base/v1.0/subscriber/operator', '[admin, admin_123]', '2018-03-12 07:07:31', '-1', 'ENABLE'), ('83', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 07:19:13', '-1', 'ENABLE'), ('84', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-12 10:13:17', '-1', 'ENABLE'), ('85', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-13 03:05:40', '-1', 'ENABLE'), ('86', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-13 08:20:13', '-1', 'ENABLE'), ('87', '110.184.144.36', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-13 16:18:01', '-1', 'ENABLE'), ('88', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', '/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-15 11:15:49', '-1', 'ENABLE'), ('89', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', '/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-15 11:23:23', '-1', 'ENABLE'), ('90', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-16 04:08:15', '-1', 'ENABLE'), ('91', '222.209.83.122', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-16 04:09:05', '-1', 'ENABLE'), ('92', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', '/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-17 00:21:46', '-1', 'ENABLE'), ('93', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', '/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-17 09:52:51', '-1', 'ENABLE'), ('94', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_ROLE_MODULE', '新增角色:测试', 'GET', '/restful/base/v1.0/role/1/10', '[RoleVo(id=null, name=测试, note=, systemCfg=false, createTime=0, createUser=1)]', '2018-03-17 10:54:22', '1', 'ENABLE'), ('95', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '设置角色12数据权限:45', 'GET', '/restful/base/v1.0/role/1/10', '[12, [45], IBSM_MANAGER_DATA_AUTH]', '2018-03-17 11:45:34', '1', 'ENABLE'), ('96', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '设置角色12数据权限:64', 'POST', '/restful/base/v1.0/auth/setting/role/data_auth', '[12, [64], IBSM_SHOPPING_DATA_AUTH]', '2018-03-17 11:47:35', '1', 'ENABLE'), ('97', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '设置角色12数据权限:64', 'POST', '/restful/base/v1.0/auth/setting/role/data_auth', '[12, [64], IBSM_SHOPPING_DATA_AUTH]', '2018-03-17 11:50:21', '1', 'ENABLE'), ('98', '125.71.100.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[test, test_123]', '2018-03-17 04:33:47', '-1', 'ENABLE'), ('99', '125.71.100.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[test, test_123]', '2018-03-17 04:33:48', '-1', 'ENABLE'), ('100', '125.71.100.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户test登陆管理平台', 'POST', 'http://manager.machu.wang/restful/base/v1.0/auth', '[test, test_123]', '2018-03-17 04:34:24', '-1', 'ENABLE'), ('101', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_AUTHORIZATION_MODULE', '用户admin登陆管理平台', 'POST', '/restful/base/v1.0/auth', '[admin, admin_123]', '2018-03-17 12:39:53', '-1', 'ENABLE'), ('102', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_SUBSCRIBER_MODULE', '修改用户[20]登录错误次数过多登陆锁定状态', 'GET', '/restful/base/v1.0/subscriber/1/10', '[20, YES]', '2018-03-17 12:54:05', '1', 'ENABLE');
INSERT INTO `hm_req_log` VALUES ('103', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_SUBSCRIBER_MODULE', '修改用户[2]登录错误次数过多登陆锁定状态', 'PATCH', '/restful/base/v1.0/subscriber/login/lock/2', '[2, NO]', '2018-03-17 12:54:48', '1', 'ENABLE'), ('104', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_SUBSCRIBER_MODULE', '修改用户[20]登录错误次数过多登陆锁定状态', 'PATCH', '/restful/base/v1.0/subscriber/login/lock/20', '[20, NO]', '2018-03-17 12:55:00', '1', 'ENABLE'), ('105', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_SUBSCRIBER_MODULE', '修改用户[20]登录错误次数过多登陆锁定状态', 'GET', '/restful/base/v1.0/subscriber/1/10', '[20, YES]', '2018-03-17 13:27:34', '1', 'ENABLE'), ('106', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_MENU_MODULE', '新增菜单信息', 'POST', '/restful/base/v1.0/menu', '[MenuVo(id=null, name=链接管理, uri=, ico=, parentId=34, parentName=null, sort=1, note=, createTime=0, systemCfg=false, createUser=1, childs=null)]', '2018-03-17 06:32:07', '1', 'ENABLE'), ('107', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_MENU_MODULE', '新增菜单信息', 'POST', '/restful/base/v1.0/menu', '[MenuVo(id=null, name=内容管理, uri=, ico=, parentId=0, parentName=null, sort=1, note=, createTime=0, systemCfg=false, createUser=1, childs=null)]', '2018-03-17 06:32:28', '1', 'ENABLE'), ('108', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_MENU_MODULE', '修改[39]菜单信息', 'PUT', '/restful/base/v1.0/menu/39', '[39, MenuVo(id=39, name=站点信息, uri=null, ico=null, parentId=null, parentName=null, sort=null, note=, createTime=0, systemCfg=false, createUser=null, childs=null)]', '2018-03-17 06:32:39', '1', 'ENABLE'), ('109', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_SYSTEM_CONFIG_DICT_MODULE', '新增数据字典信息', 'POST', '/restful/base/v1.0/syscnf', '[SystemConfigDictVo(id=null, type=CMS_LINK_TYPE, name=友情链接, code=CMS_LINK_TYPE_FRIENDSHIP, value=, note=, createTime=0, sort=1, createUser=1, systemCfg=false)]', '2018-03-17 08:43:36', '1', 'ENABLE'), ('110', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_DATA_AUTH_MODULE', '新增数据权限信息', 'POST', '/restful/base/v1.0/dtauth', '[DataAuthVo(id=null, name=分页系统链接记录, note=, moduleId=DATA_AUTH_MODULE_CMS_LINK, authCode=com.hm.cms.api.LinkApi::queryLink, sort=5, createUser=1, createTime=null, hasRole=false, systemCfg=false)]', '2018-03-17 09:21:42', '1', 'ENABLE'), ('111', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_DATA_AUTH_MODULE', '新增数据权限信息', 'POST', '/restful/base/v1.0/dtauth', '[DataAuthVo(id=null, name=新增文章信息, note=, moduleId=DATA_AUTH_MODULE_CMS_ARTICLE, authCode=com.hm.cms.api.ArticleApi::addArticle, sort=1, createUser=1, createTime=null, hasRole=false, systemCfg=false)]', '2018-03-19 10:51:54', '1', 'ENABLE'), ('112', '127.0.0.1', 'IBSM_MANAGER', 'IBSM_MANAGER_DATA_AUTH_MODULE', '新增数据权限信息', 'POST', '/restful/base/v1.0/dtauth', '[DataAuthVo(id=null, name=ue统一调用get请求, note=, moduleId=DATA_AUTH_MODULE_CMS_UE, authCode=com.hm.cms.api.UeditorApi::getInvoke, sort=1, createUser=1, createTime=null, hasRole=false, systemCfg=false)]', '2018-03-20 04:56:06', '1', 'ENABLE');
COMMIT;

-- ----------------------------
-- Table structure for `hm_role`
-- ----------------------------
DROP TABLE IF EXISTS `hm_role`;
CREATE TABLE `hm_role` (
`id`  bigint(11) NOT NULL AUTO_INCREMENT COMMENT '编号ID' ,
`name`  varchar(34) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称' ,
`system_default`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'NO' COMMENT '系统默认' ,
`note`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注描述' ,
`create_time`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`create_user`  bigint(11) NULL DEFAULT NULL COMMENT '创建人' ,
`status`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用状态' ,
PRIMARY KEY (`id`),
UNIQUE INDEX `id` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=14

;

-- ----------------------------
-- Records of hm_role
-- ----------------------------
BEGIN;
INSERT INTO `hm_role` VALUES ('1', '超级管理员', 'YES', '系统超级管理员，最高权限', '2017-06-05 14:32:34', '1', 'ENABLE'), ('2', '后台系统管理员', 'YES', '拥有登陆后台系统管理员权限', '2018-03-07 14:41:46', '1', 'DISABLE'), ('3', '商城buyer', 'NO', '商城购买用户', '2017-08-03 14:54:52', '1', 'ENABLE'), ('7', '游客', 'YES', '', '2017-06-05 14:32:35', '1', 'ENABLE'), ('8', '商城seller', 'NO', '商城卖家', '2018-02-09 07:17:40', '1', 'ENABLE');
COMMIT;

-- ----------------------------
-- Table structure for `hm_role_data_auth`
-- ----------------------------
DROP TABLE IF EXISTS `hm_role_data_auth`;
CREATE TABLE `hm_role_data_auth` (
`id`  bigint(11) NOT NULL AUTO_INCREMENT ,
`role_id`  bigint(11) NOT NULL COMMENT '角色id' ,
`data_auth_id`  bigint(11) NOT NULL COMMENT '数据权限Id' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=668

;

-- ----------------------------
-- Records of hm_role_data_auth
-- ----------------------------
BEGIN;
INSERT INTO `hm_role_data_auth` VALUES ('1', '1', '1'), ('2', '1', '2'), ('3', '1', '4'), ('4', '1', '5'), ('5', '1', '6'), ('6', '1', '7'), ('7', '1', '8'), ('8', '1', '9'), ('9', '1', '10'), ('10', '1', '11'), ('11', '1', '12'), ('12', '1', '13'), ('13', '1', '14'), ('14', '1', '15'), ('15', '1', '16'), ('16', '1', '17'), ('17', '1', '18'), ('18', '1', '19'), ('19', '1', '20'), ('20', '1', '21'), ('21', '1', '22'), ('22', '1', '23'), ('23', '1', '24'), ('24', '1', '25'), ('25', '1', '26'), ('26', '1', '27'), ('27', '1', '28'), ('28', '1', '29'), ('29', '1', '30'), ('30', '1', '31'), ('31', '1', '32'), ('32', '1', '33'), ('33', '1', '34'), ('34', '1', '35'), ('35', '1', '36'), ('36', '1', '37'), ('37', '1', '38'), ('38', '1', '39'), ('39', '1', '40'), ('40', '1', '41'), ('41', '1', '42'), ('42', '1', '43'), ('43', '1', '44'), ('44', '1', '46'), ('45', '1', '47'), ('46', '1', '48'), ('47', '1', '49'), ('48', '1', '50'), ('49', '1', '51'), ('50', '1', '52'), ('51', '1', '53'), ('52', '1', '54'), ('53', '1', '55'), ('54', '1', '56'), ('55', '1', '57'), ('56', '1', '58'), ('57', '1', '59'), ('58', '1', '60'), ('59', '1', '61'), ('60', '1', '62'), ('61', '1', '63'), ('64', '1', '64'), ('65', '1', '65'), ('66', '1', '66'), ('67', '1', '67'), ('68', '1', '68'), ('69', '1', '69'), ('70', '1', '70'), ('71', '1', '71'), ('72', '1', '72'), ('73', '1', '73'), ('74', '1', '74'), ('75', '1', '75'), ('76', '1', '76'), ('77', '1', '77'), ('78', '1', '78'), ('79', '1', '79'), ('80', '1', '80'), ('81', '1', '81'), ('82', '1', '82'), ('83', '1', '83'), ('84', '1', '84'), ('85', '1', '85'), ('86', '1', '86'), ('87', '1', '87'), ('88', '1', '88'), ('89', '1', '89'), ('110', '1', '90'), ('129', '1', '91'), ('149', '1', '92'), ('150', '1', '93'), ('171', '1', '94'), ('193', '1', '95'), ('216', '1', '96'), ('217', '1', '97'), ('241', '1', '98'), ('266', '1', '99'), ('292', '1', '100'), ('293', '1', '101'), ('447', '1', '102');
INSERT INTO `hm_role_data_auth` VALUES ('448', '1', '103'), ('449', '1', '104'), ('450', '3', '59'), ('451', '3', '60'), ('452', '3', '62'), ('453', '3', '46'), ('454', '3', '47'), ('455', '3', '48'), ('456', '3', '49'), ('457', '3', '50'), ('458', '3', '51'), ('459', '3', '52'), ('460', '3', '53'), ('461', '3', '54'), ('462', '3', '55'), ('463', '3', '56'), ('464', '3', '57'), ('465', '3', '58'), ('466', '3', '61'), ('467', '3', '63'), ('468', '3', '91'), ('469', '3', '92'), ('470', '3', '94'), ('471', '3', '95'), ('472', '3', '97'), ('473', '3', '98'), ('474', '3', '99'), ('475', '3', '102'), ('476', '3', '103'), ('477', '3', '104'), ('497', '1', '45'), ('498', '8', '100'), ('499', '8', '101'), ('500', '8', '69'), ('501', '8', '70'), ('502', '8', '71'), ('503', '8', '72'), ('504', '8', '73'), ('505', '8', '90'), ('506', '8', '74'), ('507', '8', '77'), ('508', '8', '78'), ('509', '8', '82'), ('510', '8', '17'), ('511', '8', '18'), ('512', '8', '21'), ('513', '8', '23'), ('514', '8', '24'), ('515', '8', '16'), ('516', '8', '44'), ('517', '8', '45'), ('518', '8', '4'), ('539', '1', '105'), ('540', '1', '106'), ('541', '1', '107'), ('585', '1', '108'), ('586', '1', '109'), ('599', '12', '64'), ('602', '12', '27'), ('603', '1', '110'), ('604', '1', '111'), ('605', '1', '112'), ('606', '1', '113'), ('607', '1', '114'), ('608', '1', '115'), ('609', '1', '116'), ('610', '1', '117'), ('611', '1', '118'), ('612', '1', '119'), ('613', '1', '120'), ('614', '1', '121'), ('615', '1', '122'), ('616', '7', '36'), ('617', '7', '37'), ('618', '7', '38'), ('619', '7', '39'), ('620', '7', '35'), ('621', '7', '17'), ('622', '7', '18'), ('623', '7', '21'), ('624', '7', '23'), ('625', '7', '24'), ('626', '7', '16'), ('627', '7', '45'), ('628', '7', '105'), ('629', '7', '109'), ('630', '7', '14'), ('631', '7', '15'), ('632', '7', '28'), ('633', '7', '10'), ('634', '7', '13'), ('635', '7', '4'), ('636', '7', '5'), ('637', '7', '8'), ('638', '1', '123'), ('639', '1', '124'), ('640', '1', '125'), ('641', '1', '126'), ('642', '1', '127'), ('643', '1', '128');
INSERT INTO `hm_role_data_auth` VALUES ('644', '1', '129'), ('645', '1', '130'), ('646', '1', '131'), ('647', '1', '132'), ('648', '1', '133'), ('649', '1', '134'), ('650', '1', '135'), ('651', '1', '136'), ('652', '1', '137'), ('653', '1', '138'), ('654', '1', '139'), ('655', '1', '140'), ('656', '1', '141'), ('657', '1', '142'), ('658', '1', '143'), ('659', '1', '144'), ('660', '1', '145'), ('661', '1', '146'), ('662', '1', '147'), ('663', '1', '148'), ('664', '1', '149'), ('665', '1', '150'), ('666', '1', '151'), ('667', '1', '152');
COMMIT;

-- ----------------------------
-- Table structure for `hm_role_menu`
-- ----------------------------
DROP TABLE IF EXISTS `hm_role_menu`;
CREATE TABLE `hm_role_menu` (
`id`  bigint(11) NOT NULL AUTO_INCREMENT COMMENT '编号ID' ,
`menu_id`  bigint(11) NOT NULL COMMENT '菜单ID' ,
`role_id`  bigint(11) NOT NULL COMMENT '角色ID' ,
PRIMARY KEY (`id`),
UNIQUE INDEX `id` (`id`) USING BTREE ,
INDEX `menu_id` (`menu_id`, `role_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=157

;

-- ----------------------------
-- Records of hm_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `hm_role_menu` VALUES ('73', '1', '1'), ('141', '1', '7'), ('128', '1', '8'), ('74', '2', '1'), ('75', '3', '1'), ('143', '3', '7'), ('76', '4', '1'), ('144', '4', '7'), ('77', '5', '1'), ('79', '5', '5'), ('145', '5', '7'), ('67', '6', '1'), ('146', '6', '7'), ('68', '7', '1'), ('80', '7', '5'), ('142', '7', '7'), ('69', '8', '1'), ('147', '8', '7'), ('57', '9', '1'), ('58', '10', '1'), ('70', '11', '1'), ('71', '12', '1'), ('72', '13', '1'), ('56', '14', '1'), ('59', '15', '1'), ('60', '16', '1'), ('64', '17', '1'), ('65', '18', '1'), ('66', '19', '1'), ('61', '20', '1'), ('62', '21', '1'), ('63', '22', '1'), ('81', '23', '1'), ('126', '23', '8'), ('82', '24', '1'), ('127', '24', '8'), ('83', '25', '1'), ('94', '26', '1'), ('123', '26', '8'), ('95', '27', '1'), ('96', '28', '1'), ('122', '28', '8'), ('97', '29', '1'), ('125', '29', '8'), ('98', '30', '1'), ('124', '30', '8'), ('129', '31', '1'), ('138', '33', '1'), ('139', '34', '1'), ('140', '35', '1'), ('148', '36', '1'), ('149', '37', '1'), ('150', '38', '1'), ('151', '39', '1'), ('152', '40', '1'), ('153', '41', '1'), ('154', '42', '1'), ('155', '43', '1'), ('156', '44', '1');
COMMIT;

-- ----------------------------
-- Table structure for `hm_subscriber`
-- ----------------------------
DROP TABLE IF EXISTS `hm_subscriber`;
CREATE TABLE `hm_subscriber` (
`id`  bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'ID' ,
`account`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账户' ,
`email`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱地址' ,
`user_name`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名' ,
`user_pwd`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码' ,
`phone`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话号码' ,
`sex`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别' ,
`head_portrait`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像' ,
`lost_login_ip`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '上次登陆ip地址' ,
`last_login_time`  datetime NOT NULL COMMENT '上次登录时间' ,
`parent_id`  bigint(11) NULL DEFAULT NULL COMMENT '上级联系人编号' ,
`login_lock`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'NO' COMMENT '登陆错误密码次数过多，锁死登陆' ,
`system_default`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'NO' COMMENT '系统默认' ,
`create_time`  datetime NOT NULL COMMENT '创建时间' ,
`status`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用状态' ,
PRIMARY KEY (`id`),
UNIQUE INDEX `id_index` (`id`) USING BTREE ,
INDEX `login_auth` (`account`, `user_pwd`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='登陆账户管理'
AUTO_INCREMENT=21

;

-- ----------------------------
-- Records of hm_subscriber
-- ----------------------------
BEGIN;
INSERT INTO `hm_subscriber` VALUES ('1', 'admin', '1058300241@qq.com', '三月@雪', 'd6bf4bb9a66419380a7e8b034270d381', '15884507258', 'MAN', 'http://ool4tm4nb.bkt.clouddn.com/system-manage-portrait.jpg', '127.0.0.1', '2017-06-02 17:10:29', null, 'NO', 'YES', '2017-06-02 17:10:29', 'ENABLE'), ('2', 'root', '1058300241@qq.com', '教授', '63a9f0ea7bb98050796b649e85481845', '15680249538', 'MAN', 'http://p2s9wr3uo.bkt.clouddn.com/403794252661904.png', '127.0.0.1', '2017-08-23 12:06:42', null, 'NO', 'NO', '2017-08-23 12:06:49', 'ENABLE'), ('14', 'root2', '1058300241@qq.com', '测试2', '63a9f0ea7bb98050796b649e85481845', '15884507258', 'MAN', 'http://ool4tm4nb.bkt.clouddn.com/system-manage-portrait.jpg', '127.0.0.1', '2017-08-23 12:06:49', '2', 'NO', 'NO', '2017-08-23 12:06:49', 'ENABLE'), ('18', 'maliu', '382051148@qq.com', '马六', 'd6bf4bb9a66419380a7e8b034270d381', '15380249538', 'MAN', 'http://ool4tm4nb.bkt.clouddn.com/system-manage-portrait.jpg', '127.0.0.1', '2018-01-30 15:10:49', null, 'NO', 'NO', '2018-01-30 15:10:49', 'ENABLE'), ('19', 'machu', '1@11.com', 'machu.wang', 'e10adc3949ba59abbe56e057f20f883e', '13567890234', 'MAN', 'http://p3cxjq83j.bkt.clouddn.com/610392249957157.png', '127.0.0.1', '2018-01-30 16:40:10', null, 'NO', 'NO', '2018-01-30 16:40:10', 'ENABLE'), ('20', 'test', '12@121.com', 'test', '7762dc5d78cb8366208b0c05b6fb14ea', '124567686576', 'MAN', 'http://ool4tm4nb.bkt.clouddn.com/system-manage-portrait.jpg', '127.0.0.1', '2018-02-06 07:25:41', null, 'NO', 'NO', '2018-02-06 07:25:41', 'ENABLE');
COMMIT;

-- ----------------------------
-- Table structure for `hm_subscriber_role`
-- ----------------------------
DROP TABLE IF EXISTS `hm_subscriber_role`;
CREATE TABLE `hm_subscriber_role` (
`id`  bigint(11) NOT NULL AUTO_INCREMENT COMMENT '编号ID' ,
`subscriber_id`  bigint(11) NOT NULL COMMENT '用户ID' ,
`role_id`  bigint(11) NOT NULL COMMENT '角色ID' ,
PRIMARY KEY (`id`),
UNIQUE INDEX `id` (`id`) USING BTREE ,
INDEX `subscriber_id` (`subscriber_id`, `role_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=41

;

-- ----------------------------
-- Records of hm_subscriber_role
-- ----------------------------
BEGIN;
INSERT INTO `hm_subscriber_role` VALUES ('24', '1', '1'), ('39', '2', '3'), ('27', '14', '3'), ('34', '16', '5'), ('31', '17', '1'), ('40', '18', '8'), ('38', '20', '7');
COMMIT;

-- ----------------------------
-- Table structure for `hm_system_config_dict`
-- ----------------------------
DROP TABLE IF EXISTS `hm_system_config_dict`;
CREATE TABLE `hm_system_config_dict` (
`id`  bigint(11) NOT NULL AUTO_INCREMENT COMMENT '编号ID' ,
`type`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典分类' ,
`name`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典名称' ,
`code`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典CODE' ,
`value`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典VALUE' ,
`note`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述' ,
`sort`  int(5) NOT NULL COMMENT '排列顺序' ,
`system_default`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'NO' COMMENT '系统默认配置' ,
`create_time`  datetime NOT NULL COMMENT '创建时间' ,
`create_user`  bigint(11) NULL DEFAULT NULL COMMENT '创建人' ,
`status`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据状态' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=58

;

-- ----------------------------
-- Records of hm_system_config_dict
-- ----------------------------
BEGIN;
INSERT INTO `hm_system_config_dict` VALUES ('1', 'SEX', '男', 'MAN', 'MAN', null, '1', 'YES', '2017-06-14 11:29:13', '1', 'ENABLE'), ('2', 'SEX', '女', 'WOMAN', 'WOMAN', null, '2', 'YES', '2017-06-14 11:30:42', '1', 'ENABLE'), ('3', 'MARRY', '已婚', 'MARRY_YES', 'MARRY_YES', null, '1', 'YES', '2017-06-14 11:31:53', '1', 'ENABLE'), ('4', 'MARRY', '未婚', 'MARRY_NO', 'MARRY_NO', null, '2', 'YES', '2017-06-14 11:32:12', '1', 'ENABLE'), ('5', 'IBSM_MANAGER_DATA_AUTH', '系统用户管理', 'DATA_AUTH_MODULE_SYSTEM_USER', '', '基础数据平台-系统用户管理-数据权限', '1', 'YES', '2017-12-13 11:11:26', '1', 'ENABLE'), ('6', 'IBSM_MANAGER_DATA_AUTH', '系统角色管理', 'DATA_AUTH_MODULE_SYSTEM_ROLE', null, '基础数据平台-系统角色管理-数据权限', '2', 'YES', '2017-12-13 11:14:21', '1', 'ENABLE'), ('7', 'IBSM_MANAGER_DATA_AUTH', '系统菜单管理', 'DATA_AUTH_MODULE_SYSTEM_MENU', null, '基础数据平台-系统菜单管理-数据权限', '3', 'YES', '2017-12-13 11:14:56', '1', 'ENABLE'), ('8', 'IBSM_MANAGER_DATA_AUTH', '公共服务管理', 'DATA_AUTH_MODULE_SYSTEM_COMMON', null, '基础数据平台-系统公共服务-数据权限', '4', 'YES', '2017-12-14 01:38:33', '1', 'ENABLE'), ('9', 'IBSM_MANAGER_DATA_AUTH', '系统授权管理', 'DATA_AUTH_MODULE_SYSTEM_AUTH', null, '基础数据平台-系统授权管理-数据权限', '5', 'YES', '2017-12-14 01:39:49', '1', 'ENABLE'), ('10', 'SYSTEM_BANK_LIST', '工商银行', 'CH_GS', null, null, '1', 'YES', '2017-12-17 01:14:06', '1', 'ENABLE'), ('11', 'SYSTEM_BANK_LIST', '中国银行', 'CH_YH', null, null, '2', 'YES', '2017-12-17 01:14:20', '1', 'ENABLE'), ('12', 'SYSTEM_BANK_LIST', '农业银行', 'CH_NH', null, null, '3', 'YES', '2017-12-17 01:15:11', '1', 'ENABLE'), ('13', 'SYSTEM_BANK_LIST', '建设银行', 'CH_JS', null, null, '4', 'YES', '2017-12-17 01:15:49', '1', 'ENABLE'), ('14', 'IBSM_MANAGER_DATA_AUTH', '数据权限管理', 'DATA_AUTH_MODULE_SYSTEM_DATA_AUTH', null, '基础数据平台-系统接口管理-数据权限', '6', 'YES', '2018-01-25 15:07:24', '1', 'ENABLE'), ('15', 'IBSM_MANAGER_DATA_AUTH', '系统字典管理', 'DATA_AUTH_MODULE_SYSTEM_DICT', null, '基础数据平台-系统字典管理-数据权限', '7', 'YES', '2018-01-25 15:07:24', '1', 'ENABLE'), ('16', 'IBSM_SHOPPING_DATA_AUTH', '[商城]买家个人中心', 'DATA_AUTH_MODULE_SHOPPING_PERSONAL_CENTER', null, '商城管理系统-个人中心管理-数据权限', '9', 'NO', '2018-01-25 18:20:29', '1', 'ENABLE'), ('17', 'IBSM_SHOPPING_DATA_AUTH', '[商城]公共服务管理', 'DATA_AUTH_MODULE_SHOPPING_COMMON', null, '商城管理系统-公共服务管理', '10', 'NO', '2018-01-27 13:09:47', '1', 'ENABLE'), ('20', 'IBSM_SHOPPING_DATA_AUTH', '[商城]广告信息管理', 'DATA_AUTH_MODULE_SHOPPING_ADVERTISING', '', '商城管理系统-广告信息管理-数据权限', '11', 'NO', '2018-02-05 07:25:55', '1', 'ENABLE'), ('21', 'IBSM_SHOPPING_DATA_AUTH', '[商城]商品分类管理', 'DATA_AUTH_MODULE_SHOPPING_CLASSIFICATION', '', '商城管理系统-商品分类管理-数据权限', '12', 'NO', '2018-02-05 07:27:12', '1', 'ENABLE'), ('22', 'IBSM_SHOPPING_DATA_AUTH', '[商城]商品信息管理', 'DATA_AUTH_MODULE_SHOPPING_GOODSINT', '', '商城管理系统-商品信息管理-数据权限', '13', 'NO', '2018-02-05 07:28:07', '1', 'ENABLE'), ('23', 'IBSM_SHOPPING_DATA_AUTH', '[商城]新闻公告管理', 'DATA_AUTH_MODULE_SHOPPING_NEWSANN', '', '商城管理系统-新闻公告管理-数据权限', '14', 'NO', '2018-02-05 07:29:00', '1', 'ENABLE'), ('24', 'IBSM_SHOPPING_DATA_AUTH', '[商城]订单信息管理', 'DATA_AUTH_MODULE_SHOPPING_ORDER', '', '商城管理系统-订单信息管理-数据权限', '15', 'NO', '2018-02-26 03:33:47', '1', 'ENABLE'), ('25', 'SYSTEM_DICT_TYPE', '数据权限', 'BUS_SYSTEM_PLATFORM_DATA_AUTH', null, '系统数据字典分类-数据权限', '6', 'YES', '2018-03-09 10:30:33', '1', 'ENABLE'), ('26', 'SYSTEM_DICT_TYPE', '婚姻状态', 'MARRY', null, '系统数据字典分类-婚姻状态', '3', 'YES', '2018-03-08 10:30:51', '1', 'ENABLE'), ('27', 'SYSTEM_DICT_TYPE', '性别', 'SEX', null, '系统数据字典分类-性别', '5', 'YES', '2018-03-08 10:31:31', '1', 'ENABLE'), ('28', 'SYSTEM_DICT_TYPE', '系统银行列表', 'SYSTEM_BANK_LIST', null, '系统数据字典分类-系统银行列表', '5', 'YES', '2018-03-08 10:31:44', '1', 'ENABLE'), ('29', 'SYSTEM_DICT_TYPE', '系统数据字典分类', 'SYSTEM_DICT_TYPE', null, '系统数据字典分类', '2', 'YES', '2018-02-08 10:42:25', '1', 'ENABLE'), ('30', 'SYSTEM_DICT_TYPE', '基础数据管理平台', 'BUS_SYSTEM_PLATFORM', null, '系统数据字典分类-业务系统平台', '1', 'YES', '2018-03-09 15:34:57', '1', 'ENABLE'), ('31', 'BUS_SYSTEM_PLATFORM', 'IBSM管理平台', 'IBSM_MANAGER', null, null, '1', 'YES', '2018-03-09 15:35:46', '1', 'ENABLE'), ('32', 'BUS_SYSTEM_PLATFORM', '商城管理平台', 'IBSM_SHOPPING', null, null, '2', 'YES', '2018-03-09 15:36:15', '1', 'ENABLE'), ('33', 'IBSM_MANAGER', '授权管理模块', 'IBSM_MANAGER_AUTHORIZATION_MODULE', null, null, '1', 'YES', '2018-03-09 15:37:43', '1', 'ENABLE'), ('34', 'IBSM_MANAGER', '用户管理模块', 'IBSM_MANAGER_SUBSCRIBER_MODULE', null, null, '2', 'YES', '2018-03-09 15:38:34', '1', 'ENABLE'), ('35', 'IBSM_MANAGER', '角色管理管理', 'IBSM_MANAGER_ROLE_MODULE', null, null, '3', 'YES', '2018-03-09 15:39:53', '1', 'ENABLE'), ('36', 'IBSM_MANAGER', '操作日志管理', 'DATA_AUTH_MODULE_SYSTEM_REQ_LOG', '', '基础数据平台-操作日志管理-数据权限', '8', 'YES', '2018-03-10 13:43:34', '1', 'ENABLE'), ('37', 'IBSM_MANAGER', '菜单管理模块', 'IBSM_MANAGER_MENU_MODULE', null, null, '4', 'YES', '2018-03-10 15:55:47', '1', 'ENABLE'), ('38', 'IBSM_MANAGER', '公共管理模块', 'IBSM_MANAGER_COMMMON_MODULE', null, null, '5', 'YES', '2018-03-10 15:55:56', '1', 'ENABLE'), ('39', 'IBSM_MANAGER', '数据权限管理模块', 'IBSM_MANAGER_DATA_AUTH_MODULE', null, null, '6', 'YES', '2018-03-10 15:57:02', '1', 'ENABLE'), ('40', 'IBSM_MANAGER', '系统数据字典管理', 'IBSM_MANAGER_SYSTEM_CONFIG_DICT_MODULE', null, null, '7', 'YES', '2018-03-10 15:58:09', '1', 'ENABLE'), ('41', 'BUS_SYSTEM_PLATFORM', 'CMS管理平台', 'IBSM_CMS', null, '', '3', 'YES', '2018-03-16 18:28:12', '1', 'ENABLE'), ('42', 'BUS_SYSTEM_PLATFORM_DATA_AUTH', 'IBSM管理平台', 'IBSM_MANAGER_DATA_AUTH', null, 'IBSM管理平台[数据权限]', '1', 'YES', '2018-03-16 18:35:37', '1', 'ENABLE'), ('43', 'BUS_SYSTEM_PLATFORM_DATA_AUTH', '商城管理平台', 'IBSM_SHOPPING_DATA_AUTH', null, '商城管理系统[数据权限]', '2', 'YES', '2018-03-16 18:37:04', '1', 'ENABLE'), ('44', 'SYSTEM_DICT_TYPE', '网站链接分类', 'CMS_LINK_TYPE', '', '网站管理、链接分类', '6', 'YES', '2018-03-17 08:42:29', '1', 'ENABLE'), ('45', 'CMS_LINK_TYPE', '友情链接', 'FRIENDSHIP', '', '', '1', 'YES', '2018-03-17 08:43:36', '1', 'ENABLE'), ('46', 'CMS_LINK_TYPE', '赞助商链接', 'SPONSORS', '', '', '2', 'YES', '2018-03-17 08:44:02', '1', 'ENABLE'), ('47', 'BUS_SYSTEM_PLATFORM_DATA_AUTH', '网站管理平台', 'IBSM_CMS_DATA_AUTH', null, '网站管理系统[数据权限]', '3', 'YES', '2018-03-17 17:09:41', '1', 'ENABLE'), ('48', 'IBSM_CMS_DATA_AUTH', '链接管理', 'DATA_AUTH_MODULE_CMS_LINK', null, '网站管理系统-链接管理-数据权限', '1', 'YES', '2018-03-17 17:16:21', '1', 'ENABLE'), ('49', 'IBSM_CMS_DATA_AUTH', '站点信息管理', 'DATA_AUTH_MODULE_CMS_SITE_INFO', null, '网站管理系统-站点信息管理-数据权限', '2', 'YES', '2018-03-19 01:27:34', '1', 'ENABLE'), ('50', 'IBSM_CMS_DATA_AUTH', '导航分类管理', 'DATA_AUTH_MODULE_CMS_CLASSIFICATION', null, '网站管理系统-导航分类管理-数据权限', '3', 'YES', '2018-03-19 15:47:14', '1', 'ENABLE'), ('51', 'IBSM_CMS_DATA_AUTH', '标签管理', 'DATA_AUTH_MODULE_CMS_LABLE_TAG', null, '网站管理系统-标签管理-数据权限', '4', 'YES', '2018-03-19 18:05:22', '1', 'ENABLE'), ('52', 'IBSM_CMS_DATA_AUTH', '文章管理', 'DATA_AUTH_MODULE_CMS_ARTICLE', null, '网站管理系统-内容管理-数据权限', '5', 'YES', '2018-03-19 18:50:46', '1', 'ENABLE'), ('53', 'IBSM_CMS_DATA_AUTH', 'Ueditor管理', 'DATA_AUTH_MODULE_CMS_UE', null, '网站管理系统-Ueditor管理-数据权限', '6', 'YES', '2018-03-20 12:54:25', '1', 'ENABLE'), ('54', 'IBSM_CMS_DATA_AUTH', '公共组件管理', 'DATA_AUTH_MODULE_CMS_COMMON', null, '网站管理系统-公共组件管理-数据权限', '7', 'YES', '2018-03-21 10:26:30', '1', 'ENABLE'), ('55', 'IBSM_CMS_DATA_AUTH', '黑名单管理', 'DATA_AUTH_MODULE_CMS_BLACK_IP_LIST', null, '网站管理系统-黑名单管理-数据权限', '8', 'YES', '2018-03-21 15:13:55', '1', 'ENABLE'), ('56', 'IBSM_CMS_DATA_AUTH', '广告资源管理', 'DATA_AUTH_MODULE_CMS_AD_RESOURCES', null, '网站管理系统-广告资源管理-数据权限', '9', 'YES', '2018-03-21 15:46:12', '1', 'ENABLE'), ('57', 'IBSM_CMS_DATA_AUTH', '广告投放管理', 'DATA_AUTH_MODULE_CMS_ADVERT', null, null, '10', 'YES', '2018-03-22 10:42:42', '1', 'ENABLE');
COMMIT;

-- ----------------------------
-- Auto increment value for `hm_data_auth`
-- ----------------------------
ALTER TABLE `hm_data_auth` AUTO_INCREMENT=153;

-- ----------------------------
-- Auto increment value for `hm_menu`
-- ----------------------------
ALTER TABLE `hm_menu` AUTO_INCREMENT=45;

-- ----------------------------
-- Auto increment value for `hm_nation_region`
-- ----------------------------
ALTER TABLE `hm_nation_region` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `hm_req_log`
-- ----------------------------
ALTER TABLE `hm_req_log` AUTO_INCREMENT=113;

-- ----------------------------
-- Auto increment value for `hm_role`
-- ----------------------------
ALTER TABLE `hm_role` AUTO_INCREMENT=14;

-- ----------------------------
-- Auto increment value for `hm_role_data_auth`
-- ----------------------------
ALTER TABLE `hm_role_data_auth` AUTO_INCREMENT=668;

-- ----------------------------
-- Auto increment value for `hm_role_menu`
-- ----------------------------
ALTER TABLE `hm_role_menu` AUTO_INCREMENT=157;

-- ----------------------------
-- Auto increment value for `hm_subscriber`
-- ----------------------------
ALTER TABLE `hm_subscriber` AUTO_INCREMENT=21;

-- ----------------------------
-- Auto increment value for `hm_subscriber_role`
-- ----------------------------
ALTER TABLE `hm_subscriber_role` AUTO_INCREMENT=41;

-- ----------------------------
-- Auto increment value for `hm_system_config_dict`
-- ----------------------------
ALTER TABLE `hm_system_config_dict` AUTO_INCREMENT=58;
